﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace MySqlApi
{
    public partial class index : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            Inq();
        }


        private void Inq()
        {









            string sql = " select ta.BILL_OF_LADING_NO,ta.VEHICLE_NO,ta.ORD_CUST_NAME,tb.DELI_STORE_CODE ";
            sql += " ,ta.AUDIT_DATE,tb.SG_SIGN,tb.ORD_SPEC_DESC ,tb.PICK_WT   from  ";
            sql += " TSOSD01 ta,TSOSD03 tb where ta.BILL_OF_LADING_STATUS='OP'   ";
            sql += " and ta.branch_code='G'  and ta.BILL_OF_LADING_NO= tb.BILL_OF_LADING_NO ";
            sql += " and tb.MAT_WT >=0  and   tb.prod_code='CB1' order by  ta.BILL_OF_LADING_NO ";

            sql = " select tx.* from (" + sql + " ) tx where rownum < 10 ";




            EI.EIInfo outBlock = EF.Utility.ExecQuery(sql);

            if (outBlock.sys_info.flag != 0)
            {
                return;
            }


            if (outBlock.Tables[0].Rows.Count > 0)
            {
                Repeater1.DataSource = outBlock.Tables[0];
                Repeater1.DataBind();

            }


        }
    }
}